SaStudentLedgerTermUpdatesArchive

EntityType | Independent
Logical Entity Name | SaStudentLedgerTermUpdatesArchive
Default Table Name | SaStudentLedgerTermUpdatesArchive
Logical Only | NO
Owner | dbo
Definition |
Note |

SaStudentLedgerTermUpdatesArchive Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
SaTransID |  | INTEGER | YES |
StudentEnrollmentPeriodId |  | INTEGER | YES |
OldAdTermID |  | INTEGER | YES |
NewAdTermID |  | INTEGER | YES |
SaRevenueDetailID |  | INTEGER | YES |
SaEnrollRevenueID |  | INTEGER | YES |
FaDisbID |  | INTEGER | YES |
FaSchedID |  | INTEGER | YES |
FaRefundID |  | INTEGER | YES |
AmDepositID |  | INTEGER | YES |
SaStipendSchedID |  | INTEGER | YES |
UserID |  | INTEGER | YES |
UpdateDate |  | DATETIME | YES |
RolledBack |  | BIT | YES |
SaStudentLedgerTermUpdatesArchiveID |  | INTEGER | NO |

SaStudentLedgerTermUpdatesArchive Keys

Key Name | Key Type | Keys
SaStudentLedgerTermUpdatesArchive_SaTransID_N_N_IDX | Inversion Entry | SaTransID
SaStudentLedgerTermUpdatesArchive_SaStudentLedgerTermUpdatesArchiveID | PrimaryKey | SaStudentLedgerTermUpdatesArchiveID
SaStudentLedgerTermUpdatesArchive_UserID_N_N_IDX | Inversion Entry | UserID
SaStudentLedgerTermUpdatesArchive_NewAdTermID_N_N_IDX | Inversion Entry | NewAdTermID
SaStudentLedgerTermUpdatesArchive_OldAdTermID_N_N_IDX | Inversion Entry | OldAdTermID
SaStudentLedgerTermUpdatesArchive_AdEnrollID_N_N_IDX | Inversion Entry | StudentEnrollmentPeriodId

SaStudentLedgerTermUpdatesArchive Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | NewAdTermID | NO
StudentAccountTransaction | Non-Identifying | Zero or One to Zero or More |  |  |  | SaTransID | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | UserID | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

SaStudentLedgerTermUpdatesArchive Check Constraints

Check Constraint Name | CheckConstraint

SaStudentLedgerTermUpdatesArchive Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SaStudentLedgerTermUpdatesArchive | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaStudentLedgerTermUpdatesArchive | NO |  |  |

SaStudentLedgerTermUpdatesArchive Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

SaStudentLedgerTermUpdatesArchive Data Movement Rules

Name | Type | Rule Text/Value